Text copied to clipboard!
Title
Text copied to clipboard!SQL Server Database Administrator
Description
Text copied to clipboard!
We are looking for a skilled SQL Server Database Administrator to join our dynamic team. The ideal candidate will be responsible for the installation, configuration, maintenance, and performance of critical SQL Server systems. This role requires a service-oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes. The SQL Server Database Administrator will also be responsible for ensuring high levels of data availability and performance, as well as participating in the planning and development of the database, as well as troubleshooting any issues on behalf of the users. This role requires a deep understanding of database management, data security, and the ability to work in a fast-paced environment. The successful candidate will have a proven track record of managing SQL Server databases, excellent problem-solving skills, and the ability to work both independently and as part of a team. If you are passionate about database management and looking for a challenging and rewarding role, we would love to hear from you.
Responsibilities
Text copied to clipboard!- Install, configure, and maintain SQL Server databases.
- Monitor system's health and performance.
- Ensure high levels of performance, availability, sustainability, and security.
- Analyze, solve, and correct issues in real-time.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with complex query tuning and schema refinement.
- Provide 24x7 support for critical production systems.
- Perform scheduled maintenance and support release deployment activities after hours.
- Implement and maintain database security (create and maintain users and roles, assign privileges).
- Perform database tuning and performance monitoring.
- Plan and implement backup and recovery of the SQL Server database.
- Maintain data integrity and security (manage roles and permissions of database users).
- Develop, manage, and test backup and recovery plans.
- Ensure that storage, archiving, backup, and recovery procedures are functioning correctly.
- Document database design, configuration, and maintenance procedures.
Requirements
Text copied to clipboard!- Bachelor’s degree in Computer Science or related field.
- 5+ years of experience as a SQL Server DBA or similar role.
- Experience with Performance Tuning and Optimization (PTO).
- Experience with backups, restores, and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Experience with Windows server, including Active Directory.
- Excellent written and verbal communication.
- Flexible, team player, “get-it-done” personality.
- Ability to organize and plan work independently.
- Ability to work in a rapidly changing environment.
- Ability to multi-task and context-switch effectively between different activities and teams.
- MCSA or MCSE certifications are a plus.
- Experience with cloud services (AWS, Azure) is a plus.
- Strong understanding of database structures, theories, principles, and practices.
Potential interview questions
Text copied to clipboard!- Can you describe your experience with SQL Server performance tuning?
- How do you handle database backup and recovery?
- What strategies do you use to ensure database security?
- Can you provide an example of a complex problem you solved as a DBA?
- How do you stay updated with the latest database technologies?
- Describe a time when you had to work under pressure to resolve a critical database issue.
- What is your experience with High Availability and Disaster Recovery options for SQL Server?
- How do you approach database schema design and optimization?
- Can you explain your experience with cloud-based database services?
- What tools do you use for database monitoring and management?